总账核销
概述
核销原理
未核销报表
自动核销
(CASE WHEN fa.AD_Table_ID = 318 /* C_Invoice */
THEN (SELECT (CASE WHEN i.DocStatus IN ('VO','RE') AND i.Reversal_ID > 0
THEN 'Auto C_Invoice Reversed:' || least(i.C_Invoice_ID, i.Reversal_ID)
WHEN i.DocStatus = 'VO'
THEN 'Auto C_Invoice Voided:' || i.C_Invoice_ID
ELSE 'Auto C_Invoice:' || fa.Record_ID END)
FROM C_Invoice i
WHERE i.C_Invoice_ID=fa.Record_ID)
WHEN fa.AD_Table_ID = 735 /* C_AllocationHdr */
THEN (SELECT 'Auto C_Invoice:' || al.C_Invoice_ID FROM C_AllocationLine al
WHERE al.C_AllocationHdr_ID = fa.Record_ID
AND al.C_AllocationLine_ID = fa.Line_ID ) END)